﻿CREATE PROCEDURE [dbo].[proc_Ab_Interface_GetListByCompanyIdExt]
(
	@CompanyId INT	
)
AS
BEGIN
	SELECT 
		id
		,CompanyId
		,Companyname
		,ProductId
		,Productname
		,syzh

	  FROM AB_Interface 
	WHERE CompanyId=@CompanyId AND syzh=0
	ORDER BY Productname,CompanyId

	SET NOCOUNT ON;
END